---
title: MindsDB SQL
sidebarTitle: Overview
---

MindsDB offers a tailored SQL syntax that enables seamless interaction with a wide range of objects, including databases, projects, models, views, tables, files, and jobs. Moreover, you have the flexibility to connect MindsDB with various SQL clients, facilitating streamlined integration.

### Connect to MindsDB

This section contains guides on how to connect MindsDB to various SQL clients.

<CardGroup cols={4}>

    <Card title="MindsDB SQL Editor" icon="link" href="/connect/mindsdb_editor"></Card>
    <Card title="Postgres CLI" icon="link" href="/connect/postgres-client"></Card>
    <Card title="MySQL CLI" icon="link" href="/connect/mysql-client"></Card>
    <Card title="DBeaver" icon="link" href="/connect/dbeaver"></Card>
    <Card title="MariaDB SkySQL" icon="link" href="/connect/connect-mariadb-skysql"></Card>
    <Card title="SQL Alchemy" icon="link" href="/connect/sql-alchemy"></Card>
    <Card title="Deepnote" icon="link" href="/connect/deepnote"></Card>
    <Card title="Metabase" icon="link" href="/connect/metabase"></Card>
    <Card title="Tableau" icon="link" href="/connect/tableau"></Card>
    <Card title="Jupyter Notebooks" icon="link" href="/connect/jupysql"></Card>
    <Card title="Grafana" icon="link" href="/connect/grafana"></Card>

</CardGroup>

### SQL Syntax

This section contains guides on how to work with databases, projects, models, views, tables, files, and jobs.

#### Databases

<CardGroup cols={4}>

    <Card title="CREATE DATABASE" icon="link" href="/sql/create/database"></Card>
    <Card title="DROP DATABASE" icon="link" href="/sql/drop/database"></Card>
    <Card title="USE" icon="link" href="/sql/api/use"></Card>

</CardGroup>

#### Projects

<CardGroup cols={4}>

    <Card title="CREATE PROJECT" icon="link" href="/sql/create/project"></Card>
    <Card title="DROP PROJECT" icon="link" href="/sql/drop/project"></Card>

</CardGroup>

#### Models

<CardGroup cols={4}>

    <Card title="CREATE ML_ENGINE" icon="link" href="/sql/create/ml-engine"></Card>
    <Card title="DROP ML_ENGINE" icon="link" href="/sql/drop/ml-engine"></Card>
    <Card title="CREATE MODEL" icon="link" href="/sql/create/model"></Card>
    <Card title="DROP MODEL" icon="link" href="/sql/drop/model"></Card>
    <Card title="JOIN" icon="link" href="/sql/api/join"></Card>
    <Card title="DESCRIBE" icon="link" href="/sql/api/describe"></Card>
    <Card title="RETRAIN" icon="link" href="/sql/api/retrain"></Card>
    <Card title="FINETUNE" icon="link" href="/sql/api/finetune"></Card>
    <Card title="Manage Model Versions" icon="link" href="/sql/api/manage-models-versions"></Card>

</CardGroup>

#### Views

<CardGroup cols={4}>

    <Card title="CREATE VIEW" icon="link" href="/sql/create/view"></Card>
    <Card title="DROP VIEW" icon="link" href="/sql/drop/view"></Card>

</CardGroup>

#### Tables

<CardGroup cols={4}>

    <Card title="CREATE TABLE" icon="link" href="/sql/create/table"></Card>
    <Card title="DROP TABLE" icon="link" href="/sql/drop/table"></Card>
    <Card title="SELECT" icon="link" href="/sql/api/select"></Card>
    <Card title="UPDATE" icon="link" href="/sql/api/update"></Card>
    <Card title="INSERT INTO" icon="link" href="/sql/api/insert"></Card>
    <Card title="JOIN ON" icon="link" href="/sql/api/join-on"></Card>

</CardGroup>

#### Files

<CardGroup cols={4}>

    <Card title="Upload a File" icon="link" href="/sql/create/file"></Card>
    <Card title="Drop a File" icon="link" href="/sql/drop/file"></Card>
    <Card title="SELECT FROM files" icon="link" href="/sql/api/select-files"></Card>

</CardGroup>

#### Jobs

<CardGroup cols={4}>

    <Card title="CREATE JOB" icon="link" href="/sql/create/jobs"></Card>
    <Card title="DROP JOB" icon="link" href="/sql/drop/jobs"></Card>

</CardGroup>
